{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-08-15T07:07:34.868892Z",
     "start_time": "2019-08-15T07:07:33.963314Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>ORDER_NO</th>\n",
       "      <th>PARENT_ORDER_NO</th>\n",
       "      <th>ACCEPT_TIME</th>\n",
       "      <th>ACCEPT_CHANNEL</th>\n",
       "      <th>TXN_TIME</th>\n",
       "      <th>TXN_AMOUNT</th>\n",
       "      <th>TXN_STATUS</th>\n",
       "      <th>BUSINESS_TYPE</th>\n",
       "      <th>COMPLETE_TIME</th>\n",
       "      <th>...</th>\n",
       "      <th>CREATED_TIME</th>\n",
       "      <th>UPDATED_BY.1</th>\n",
       "      <th>UPDATED_TIME</th>\n",
       "      <th>ACTIVITY_ID</th>\n",
       "      <th>SEQ_NO</th>\n",
       "      <th>ARCHIVE_FLAG</th>\n",
       "      <th>FROZEN_CAL_DATE</th>\n",
       "      <th>WITHHOLD_STATUS</th>\n",
       "      <th>PARTITION_NUM</th>\n",
       "      <th>REMARK.1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2019070109040317286346</td>\n",
       "      <td>190717640617</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 9:04:03</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 9:04:03</td>\n",
       "      <td>195100</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 9:07:22</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 9:07:22</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/7/1 9:32:11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>222960176</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2019070109105417286619</td>\n",
       "      <td>190717640690</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 9:10:54</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 9:10:54</td>\n",
       "      <td>39000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 9:20:55</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 9:20:56</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/3 10:43:02</td>\n",
       "      <td>NaN</td>\n",
       "      <td>222964154</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2019070109121017286501</td>\n",
       "      <td>190717640515</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 9:12:10</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 9:12:10</td>\n",
       "      <td>39000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 9:32:27</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 9:32:28</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/3 19:35:35</td>\n",
       "      <td>NaN</td>\n",
       "      <td>222968036</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2019070109163217286663</td>\n",
       "      <td>190717640734</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 9:16:32</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 9:16:32</td>\n",
       "      <td>97500</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 9:21:05</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 9:21:06</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 12:54:49</td>\n",
       "      <td>NaN</td>\n",
       "      <td>222964498</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2019070109255817286769</td>\n",
       "      <td>190717641040</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 9:25:58</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 9:25:58</td>\n",
       "      <td>78000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 9:34:25</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 9:34:26</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/3 9:47:24</td>\n",
       "      <td>NaN</td>\n",
       "      <td>222968572</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2019070109280317286785</td>\n",
       "      <td>190717641056</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 9:28:03</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 9:28:03</td>\n",
       "      <td>113100</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 9:33:04</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 9:33:04</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 12:54:49</td>\n",
       "      <td>NaN</td>\n",
       "      <td>222968282</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2019070109400617287214</td>\n",
       "      <td>190717641228</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 9:40:06</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 9:40:06</td>\n",
       "      <td>97500</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 9:42:37</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 9:42:37</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/5 17:29:44</td>\n",
       "      <td>NaN</td>\n",
       "      <td>222971880</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7868</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2019070109545017287554</td>\n",
       "      <td>190717641825</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 9:54:50</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 9:54:50</td>\n",
       "      <td>63400</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 12:13:33</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 12:13:34</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/4 3:56:31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>223071592</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2019070109550617287562</td>\n",
       "      <td>190717641833</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 9:55:06</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 9:55:06</td>\n",
       "      <td>100000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:00:03</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 10:00:04</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/3 21:13:05</td>\n",
       "      <td>NaN</td>\n",
       "      <td>222980836</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7868</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2019070110013517287718</td>\n",
       "      <td>190717641732</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 10:01:35</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:01:35</td>\n",
       "      <td>97500</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:08:09</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 10:08:09</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 12:54:49</td>\n",
       "      <td>NaN</td>\n",
       "      <td>222984712</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2019070110093917288217</td>\n",
       "      <td>190717642087</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 10:09:39</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:09:39</td>\n",
       "      <td>58500</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:15:45</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 10:15:46</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/3 22:35:58</td>\n",
       "      <td>NaN</td>\n",
       "      <td>222989490</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7868</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2019070110131617288302</td>\n",
       "      <td>190717642172</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 10:13:16</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:13:16</td>\n",
       "      <td>83900</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:15:09</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 10:15:09</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/7/1 10:15:33</td>\n",
       "      <td>NaN</td>\n",
       "      <td>222989002</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2019070110132717288306</td>\n",
       "      <td>190717642176</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 10:13:27</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:13:27</td>\n",
       "      <td>64300</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:16:40</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 10:16:41</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/7/1 10:19:26</td>\n",
       "      <td>NaN</td>\n",
       "      <td>222989382</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2019070110133617288309</td>\n",
       "      <td>190717642179</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 10:13:36</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:13:36</td>\n",
       "      <td>39000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:25:38</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 10:25:39</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/3 8:33:18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>222995344</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2019070110173717288388</td>\n",
       "      <td>190717642458</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 10:17:37</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:17:37</td>\n",
       "      <td>97500</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:22:58</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 10:22:59</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/3 19:57:15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>222993864</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2019070110231317288519</td>\n",
       "      <td>190717642589</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 10:23:13</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:23:13</td>\n",
       "      <td>78000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 11:00:11</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 11:00:12</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/3 10:56:45</td>\n",
       "      <td>NaN</td>\n",
       "      <td>223018900</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2019070110235717288687</td>\n",
       "      <td>190717642702</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 10:23:57</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:23:57</td>\n",
       "      <td>97500</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:29:50</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 10:29:51</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/7/1 14:21:11</td>\n",
       "      <td>NaN</td>\n",
       "      <td>222997834</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2019070110254717288563</td>\n",
       "      <td>190717642833</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 10:25:47</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:25:47</td>\n",
       "      <td>156000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:28:59</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 10:28:59</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/3 20:57:50</td>\n",
       "      <td>NaN</td>\n",
       "      <td>222997170</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2019070110255517288711</td>\n",
       "      <td>190717642726</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 10:25:55</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:25:55</td>\n",
       "      <td>97500</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:32:13</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 10:32:13</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/4 22:35:53</td>\n",
       "      <td>NaN</td>\n",
       "      <td>222999644</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2019070110311717289043</td>\n",
       "      <td>190717643058</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 10:31:17</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:31:17</td>\n",
       "      <td>78000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 11:00:10</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 11:00:10</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/3 10:28:19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>223018852</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2019070110325717288902</td>\n",
       "      <td>190717642972</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 10:32:57</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:32:57</td>\n",
       "      <td>39000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:36:52</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 10:36:52</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/4 11:19:13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>223002924</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2019070110362217288958</td>\n",
       "      <td>190717643228</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 10:36:22</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:36:22</td>\n",
       "      <td>195100</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:51:56</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 10:51:57</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/3 19:49:28</td>\n",
       "      <td>NaN</td>\n",
       "      <td>223012588</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2019070110394617289411</td>\n",
       "      <td>190717643282</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 10:39:46</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:39:46</td>\n",
       "      <td>78000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:43:08</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 10:43:09</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/3 20:50:23</td>\n",
       "      <td>NaN</td>\n",
       "      <td>223006502</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2019070110423217289323</td>\n",
       "      <td>190717643536</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 10:42:32</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:42:32</td>\n",
       "      <td>97500</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 11:00:19</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 11:00:20</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/4 4:50:37</td>\n",
       "      <td>NaN</td>\n",
       "      <td>223019020</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2019070110525117289864</td>\n",
       "      <td>190717643936</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 10:52:51</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:52:51</td>\n",
       "      <td>195100</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:57:31</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 10:57:32</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/2 15:14:17</td>\n",
       "      <td>NaN</td>\n",
       "      <td>223016946</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2019070110555717290036</td>\n",
       "      <td>190717644049</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 10:55:57</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:55:57</td>\n",
       "      <td>64300</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:57:41</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 10:57:41</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/4 16:32:37</td>\n",
       "      <td>NaN</td>\n",
       "      <td>223017218</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2019070110582017289997</td>\n",
       "      <td>190717644269</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 10:58:20</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 10:58:20</td>\n",
       "      <td>146300</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 11:01:37</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 11:01:37</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/7/1 11:48:25</td>\n",
       "      <td>NaN</td>\n",
       "      <td>223020040</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2019070111000317290235</td>\n",
       "      <td>190717644307</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 11:00:03</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 11:00:03</td>\n",
       "      <td>179900</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 11:06:17</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 11:06:17</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/5 9:58:43</td>\n",
       "      <td>NaN</td>\n",
       "      <td>223023448</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2019070111015817290155</td>\n",
       "      <td>190717644168</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 11:01:58</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 11:01:58</td>\n",
       "      <td>58500</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 11:07:38</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 11:07:39</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/6 13:59:21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>223024562</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2019070111034417290328</td>\n",
       "      <td>190717644600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/1 11:03:44</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 11:03:44</td>\n",
       "      <td>99500</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/1 11:06:22</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/1 11:06:22</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/4 4:50:37</td>\n",
       "      <td>NaN</td>\n",
       "      <td>223022852</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>7869</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14135</th>\n",
       "      <td>2019073119120718145214</td>\n",
       "      <td>190718499261</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 19:12:07</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 19:12:07</td>\n",
       "      <td>117000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 19:15:34</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 19:15:35</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237858920</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14136</th>\n",
       "      <td>2019073119253418145558</td>\n",
       "      <td>190718499596</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 19:25:34</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 19:25:34</td>\n",
       "      <td>97500</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:48:29</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 20:48:29</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/7/31 20:55:38</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237901536</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14137</th>\n",
       "      <td>2019073121162618148028</td>\n",
       "      <td>190718502076</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 21:16:26</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 21:16:26</td>\n",
       "      <td>39000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 21:19:07</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 21:19:08</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:45</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237910700</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14138</th>\n",
       "      <td>2019073120553218147691</td>\n",
       "      <td>190718501739</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 20:55:32</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:55:32</td>\n",
       "      <td>39000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 21:01:12</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 21:01:12</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:45</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237905748</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14139</th>\n",
       "      <td>2019073120552918147550</td>\n",
       "      <td>190718501587</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 20:55:29</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:55:29</td>\n",
       "      <td>78000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 21:16:35</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 21:16:36</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/7/31 21:53:58</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237909740</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14140</th>\n",
       "      <td>2019073121103518147788</td>\n",
       "      <td>190718502036</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 21:10:35</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 21:10:35</td>\n",
       "      <td>78000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 21:13:16</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 21:13:16</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:46</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237909184</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14141</th>\n",
       "      <td>2019073121315818147989</td>\n",
       "      <td>190718502227</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 21:31:58</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 21:31:58</td>\n",
       "      <td>464300</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 21:35:16</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 21:35:17</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/9 11:02:40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237914678</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14142</th>\n",
       "      <td>2019073121111718147881</td>\n",
       "      <td>190718501918</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 21:11:17</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 21:11:17</td>\n",
       "      <td>78000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 21:16:22</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 21:16:23</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:45</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237909894</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14143</th>\n",
       "      <td>2019073121062618147845</td>\n",
       "      <td>190718501882</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 21:06:26</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 21:06:26</td>\n",
       "      <td>39000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 21:11:18</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 21:11:18</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:48</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237908520</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14144</th>\n",
       "      <td>2019073121014418147740</td>\n",
       "      <td>190718501788</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 21:01:44</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 21:01:44</td>\n",
       "      <td>39000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 21:21:56</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 21:21:56</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237911190</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14145</th>\n",
       "      <td>2019073119563518146469</td>\n",
       "      <td>190718500515</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 19:56:35</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 19:56:35</td>\n",
       "      <td>39000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:01:52</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 20:01:52</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237883788</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14146</th>\n",
       "      <td>2019073120284018147123</td>\n",
       "      <td>190718501161</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 20:28:40</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:28:40</td>\n",
       "      <td>39000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 21:24:26</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 21:24:26</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:45</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237912310</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14147</th>\n",
       "      <td>2019073119545318146446</td>\n",
       "      <td>190718500493</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 19:54:53</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 19:54:53</td>\n",
       "      <td>97500</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:00:24</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 20:00:24</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:30</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237883240</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14148</th>\n",
       "      <td>2019073119481818146149</td>\n",
       "      <td>190718500196</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 19:48:18</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 19:48:18</td>\n",
       "      <td>78000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 19:51:18</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 19:51:19</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:45</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237878665</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14149</th>\n",
       "      <td>2019073119520818146199</td>\n",
       "      <td>190718500446</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 19:52:08</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 19:52:08</td>\n",
       "      <td>39000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:03:35</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 20:03:36</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:35</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237884436</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14150</th>\n",
       "      <td>2019073120590118147723</td>\n",
       "      <td>190718501771</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 20:59:01</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:59:01</td>\n",
       "      <td>78000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 21:39:54</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 21:39:54</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:36</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237915570</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14151</th>\n",
       "      <td>2019073120462518147620</td>\n",
       "      <td>190718501667</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 20:46:25</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:46:25</td>\n",
       "      <td>336000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:49:41</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 20:49:42</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:48</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237902118</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14152</th>\n",
       "      <td>2019073120000418146513</td>\n",
       "      <td>190718500559</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 20:00:04</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:00:04</td>\n",
       "      <td>195100</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:23:07</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 20:23:08</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/7/31 20:40:18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237892456</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14153</th>\n",
       "      <td>2019073120081718146821</td>\n",
       "      <td>190718500867</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 20:08:17</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:08:17</td>\n",
       "      <td>37000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:13:52</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 20:13:53</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:41</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237888688</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14154</th>\n",
       "      <td>2019073120231818147072</td>\n",
       "      <td>190718501110</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 20:23:18</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:23:18</td>\n",
       "      <td>100000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:25:56</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 20:25:57</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:35</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237893684</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14155</th>\n",
       "      <td>2019073120135818146773</td>\n",
       "      <td>190718501012</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 20:13:58</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:13:58</td>\n",
       "      <td>58500</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:19:15</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 20:19:16</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:48</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237891032</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14156</th>\n",
       "      <td>2019073120212018146946</td>\n",
       "      <td>190718500993</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 20:21:20</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:21:20</td>\n",
       "      <td>58500</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:23:48</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 20:23:49</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237892872</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14157</th>\n",
       "      <td>2019073120230218146968</td>\n",
       "      <td>190718501215</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 20:23:02</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:23:02</td>\n",
       "      <td>97500</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:39:38</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 20:39:38</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:31</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237898806</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14158</th>\n",
       "      <td>2019073120374818147409</td>\n",
       "      <td>190718501447</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 20:37:48</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:37:48</td>\n",
       "      <td>58500</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:42:29</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 20:42:30</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:41</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237900032</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14159</th>\n",
       "      <td>2019073120185018146928</td>\n",
       "      <td>190718500974</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 20:18:50</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:18:50</td>\n",
       "      <td>39000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:40:13</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 20:40:13</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:40</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237898830</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14160</th>\n",
       "      <td>2019073120281818147118</td>\n",
       "      <td>190718501156</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 20:28:18</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:28:18</td>\n",
       "      <td>97500</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 21:25:59</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 21:25:59</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:41</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237912678</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14161</th>\n",
       "      <td>2019073120291518147129</td>\n",
       "      <td>190718501167</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 20:29:15</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:29:15</td>\n",
       "      <td>78000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:58:18</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 20:58:19</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:35</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237905136</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14162</th>\n",
       "      <td>2019073120332018147284</td>\n",
       "      <td>190718501331</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 20:33:20</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:33:20</td>\n",
       "      <td>97500</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 21:25:33</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 21:25:33</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/7/31 21:38:29</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237912528</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14163</th>\n",
       "      <td>2019073120484118147641</td>\n",
       "      <td>190718501688</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 20:48:41</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:48:41</td>\n",
       "      <td>117000</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:52:49</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 20:52:50</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:48</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237903214</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14164</th>\n",
       "      <td>2019073120412918147362</td>\n",
       "      <td>190718501609</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2019/7/31 20:41:29</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 20:41:29</td>\n",
       "      <td>97500</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2019/7/31 21:02:03</td>\n",
       "      <td>...</td>\n",
       "      <td>2019/7/31 21:02:03</td>\n",
       "      <td>BILLCENTER</td>\n",
       "      <td>2019/8/8 16:38:35</td>\n",
       "      <td>NaN</td>\n",
       "      <td>237906152</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>READY</td>\n",
       "      <td>8997</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>14165 rows × 132 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                           ID      ORDER_NO  PARENT_ORDER_NO  \\\n",
       "0      2019070109040317286346  190717640617              NaN   \n",
       "1      2019070109105417286619  190717640690              NaN   \n",
       "2      2019070109121017286501  190717640515              NaN   \n",
       "3      2019070109163217286663  190717640734              NaN   \n",
       "4      2019070109255817286769  190717641040              NaN   \n",
       "5      2019070109280317286785  190717641056              NaN   \n",
       "6      2019070109400617287214  190717641228              NaN   \n",
       "7      2019070109545017287554  190717641825              NaN   \n",
       "8      2019070109550617287562  190717641833              NaN   \n",
       "9      2019070110013517287718  190717641732              NaN   \n",
       "10     2019070110093917288217  190717642087              NaN   \n",
       "11     2019070110131617288302  190717642172              NaN   \n",
       "12     2019070110132717288306  190717642176              NaN   \n",
       "13     2019070110133617288309  190717642179              NaN   \n",
       "14     2019070110173717288388  190717642458              NaN   \n",
       "15     2019070110231317288519  190717642589              NaN   \n",
       "16     2019070110235717288687  190717642702              NaN   \n",
       "17     2019070110254717288563  190717642833              NaN   \n",
       "18     2019070110255517288711  190717642726              NaN   \n",
       "19     2019070110311717289043  190717643058              NaN   \n",
       "20     2019070110325717288902  190717642972              NaN   \n",
       "21     2019070110362217288958  190717643228              NaN   \n",
       "22     2019070110394617289411  190717643282              NaN   \n",
       "23     2019070110423217289323  190717643536              NaN   \n",
       "24     2019070110525117289864  190717643936              NaN   \n",
       "25     2019070110555717290036  190717644049              NaN   \n",
       "26     2019070110582017289997  190717644269              NaN   \n",
       "27     2019070111000317290235  190717644307              NaN   \n",
       "28     2019070111015817290155  190717644168              NaN   \n",
       "29     2019070111034417290328  190717644600              NaN   \n",
       "...                       ...           ...              ...   \n",
       "14135  2019073119120718145214  190718499261              NaN   \n",
       "14136  2019073119253418145558  190718499596              NaN   \n",
       "14137  2019073121162618148028  190718502076              NaN   \n",
       "14138  2019073120553218147691  190718501739              NaN   \n",
       "14139  2019073120552918147550  190718501587              NaN   \n",
       "14140  2019073121103518147788  190718502036              NaN   \n",
       "14141  2019073121315818147989  190718502227              NaN   \n",
       "14142  2019073121111718147881  190718501918              NaN   \n",
       "14143  2019073121062618147845  190718501882              NaN   \n",
       "14144  2019073121014418147740  190718501788              NaN   \n",
       "14145  2019073119563518146469  190718500515              NaN   \n",
       "14146  2019073120284018147123  190718501161              NaN   \n",
       "14147  2019073119545318146446  190718500493              NaN   \n",
       "14148  2019073119481818146149  190718500196              NaN   \n",
       "14149  2019073119520818146199  190718500446              NaN   \n",
       "14150  2019073120590118147723  190718501771              NaN   \n",
       "14151  2019073120462518147620  190718501667              NaN   \n",
       "14152  2019073120000418146513  190718500559              NaN   \n",
       "14153  2019073120081718146821  190718500867              NaN   \n",
       "14154  2019073120231818147072  190718501110              NaN   \n",
       "14155  2019073120135818146773  190718501012              NaN   \n",
       "14156  2019073120212018146946  190718500993              NaN   \n",
       "14157  2019073120230218146968  190718501215              NaN   \n",
       "14158  2019073120374818147409  190718501447              NaN   \n",
       "14159  2019073120185018146928  190718500974              NaN   \n",
       "14160  2019073120281818147118  190718501156              NaN   \n",
       "14161  2019073120291518147129  190718501167              NaN   \n",
       "14162  2019073120332018147284  190718501331              NaN   \n",
       "14163  2019073120484118147641  190718501688              NaN   \n",
       "14164  2019073120412918147362  190718501609              NaN   \n",
       "\n",
       "              ACCEPT_TIME  ACCEPT_CHANNEL            TXN_TIME  TXN_AMOUNT  \\\n",
       "0        2019/7/1 9:04:03               2    2019/7/1 9:04:03      195100   \n",
       "1        2019/7/1 9:10:54               2    2019/7/1 9:10:54       39000   \n",
       "2        2019/7/1 9:12:10               2    2019/7/1 9:12:10       39000   \n",
       "3        2019/7/1 9:16:32               2    2019/7/1 9:16:32       97500   \n",
       "4        2019/7/1 9:25:58               2    2019/7/1 9:25:58       78000   \n",
       "5        2019/7/1 9:28:03               2    2019/7/1 9:28:03      113100   \n",
       "6        2019/7/1 9:40:06               2    2019/7/1 9:40:06       97500   \n",
       "7        2019/7/1 9:54:50               2    2019/7/1 9:54:50       63400   \n",
       "8        2019/7/1 9:55:06               2    2019/7/1 9:55:06      100000   \n",
       "9       2019/7/1 10:01:35               2   2019/7/1 10:01:35       97500   \n",
       "10      2019/7/1 10:09:39               2   2019/7/1 10:09:39       58500   \n",
       "11      2019/7/1 10:13:16               2   2019/7/1 10:13:16       83900   \n",
       "12      2019/7/1 10:13:27               2   2019/7/1 10:13:27       64300   \n",
       "13      2019/7/1 10:13:36               2   2019/7/1 10:13:36       39000   \n",
       "14      2019/7/1 10:17:37               2   2019/7/1 10:17:37       97500   \n",
       "15      2019/7/1 10:23:13               2   2019/7/1 10:23:13       78000   \n",
       "16      2019/7/1 10:23:57               2   2019/7/1 10:23:57       97500   \n",
       "17      2019/7/1 10:25:47               2   2019/7/1 10:25:47      156000   \n",
       "18      2019/7/1 10:25:55               2   2019/7/1 10:25:55       97500   \n",
       "19      2019/7/1 10:31:17               2   2019/7/1 10:31:17       78000   \n",
       "20      2019/7/1 10:32:57               2   2019/7/1 10:32:57       39000   \n",
       "21      2019/7/1 10:36:22               2   2019/7/1 10:36:22      195100   \n",
       "22      2019/7/1 10:39:46               2   2019/7/1 10:39:46       78000   \n",
       "23      2019/7/1 10:42:32               2   2019/7/1 10:42:32       97500   \n",
       "24      2019/7/1 10:52:51               2   2019/7/1 10:52:51      195100   \n",
       "25      2019/7/1 10:55:57               2   2019/7/1 10:55:57       64300   \n",
       "26      2019/7/1 10:58:20               2   2019/7/1 10:58:20      146300   \n",
       "27      2019/7/1 11:00:03               2   2019/7/1 11:00:03      179900   \n",
       "28      2019/7/1 11:01:58               2   2019/7/1 11:01:58       58500   \n",
       "29      2019/7/1 11:03:44               2   2019/7/1 11:03:44       99500   \n",
       "...                   ...             ...                 ...         ...   \n",
       "14135  2019/7/31 19:12:07               2  2019/7/31 19:12:07      117000   \n",
       "14136  2019/7/31 19:25:34               2  2019/7/31 19:25:34       97500   \n",
       "14137  2019/7/31 21:16:26               2  2019/7/31 21:16:26       39000   \n",
       "14138  2019/7/31 20:55:32               2  2019/7/31 20:55:32       39000   \n",
       "14139  2019/7/31 20:55:29               2  2019/7/31 20:55:29       78000   \n",
       "14140  2019/7/31 21:10:35               2  2019/7/31 21:10:35       78000   \n",
       "14141  2019/7/31 21:31:58               2  2019/7/31 21:31:58      464300   \n",
       "14142  2019/7/31 21:11:17               2  2019/7/31 21:11:17       78000   \n",
       "14143  2019/7/31 21:06:26               2  2019/7/31 21:06:26       39000   \n",
       "14144  2019/7/31 21:01:44               2  2019/7/31 21:01:44       39000   \n",
       "14145  2019/7/31 19:56:35               2  2019/7/31 19:56:35       39000   \n",
       "14146  2019/7/31 20:28:40               2  2019/7/31 20:28:40       39000   \n",
       "14147  2019/7/31 19:54:53               2  2019/7/31 19:54:53       97500   \n",
       "14148  2019/7/31 19:48:18               2  2019/7/31 19:48:18       78000   \n",
       "14149  2019/7/31 19:52:08               2  2019/7/31 19:52:08       39000   \n",
       "14150  2019/7/31 20:59:01               2  2019/7/31 20:59:01       78000   \n",
       "14151  2019/7/31 20:46:25               2  2019/7/31 20:46:25      336000   \n",
       "14152  2019/7/31 20:00:04               2  2019/7/31 20:00:04      195100   \n",
       "14153  2019/7/31 20:08:17               2  2019/7/31 20:08:17       37000   \n",
       "14154  2019/7/31 20:23:18               2  2019/7/31 20:23:18      100000   \n",
       "14155  2019/7/31 20:13:58               2  2019/7/31 20:13:58       58500   \n",
       "14156  2019/7/31 20:21:20               2  2019/7/31 20:21:20       58500   \n",
       "14157  2019/7/31 20:23:02               2  2019/7/31 20:23:02       97500   \n",
       "14158  2019/7/31 20:37:48               2  2019/7/31 20:37:48       58500   \n",
       "14159  2019/7/31 20:18:50               2  2019/7/31 20:18:50       39000   \n",
       "14160  2019/7/31 20:28:18               2  2019/7/31 20:28:18       97500   \n",
       "14161  2019/7/31 20:29:15               2  2019/7/31 20:29:15       78000   \n",
       "14162  2019/7/31 20:33:20               2  2019/7/31 20:33:20       97500   \n",
       "14163  2019/7/31 20:48:41               2  2019/7/31 20:48:41      117000   \n",
       "14164  2019/7/31 20:41:29               2  2019/7/31 20:41:29       97500   \n",
       "\n",
       "       TXN_STATUS  BUSINESS_TYPE       COMPLETE_TIME  ...        CREATED_TIME  \\\n",
       "0               4              2    2019/7/1 9:07:22  ...    2019/7/1 9:07:22   \n",
       "1               4              2    2019/7/1 9:20:55  ...    2019/7/1 9:20:56   \n",
       "2               4              2    2019/7/1 9:32:27  ...    2019/7/1 9:32:28   \n",
       "3               4              2    2019/7/1 9:21:05  ...    2019/7/1 9:21:06   \n",
       "4               4              2    2019/7/1 9:34:25  ...    2019/7/1 9:34:26   \n",
       "5               4              2    2019/7/1 9:33:04  ...    2019/7/1 9:33:04   \n",
       "6               4              2    2019/7/1 9:42:37  ...    2019/7/1 9:42:37   \n",
       "7               4              2   2019/7/1 12:13:33  ...   2019/7/1 12:13:34   \n",
       "8               4              2   2019/7/1 10:00:03  ...   2019/7/1 10:00:04   \n",
       "9               4              2   2019/7/1 10:08:09  ...   2019/7/1 10:08:09   \n",
       "10              4              2   2019/7/1 10:15:45  ...   2019/7/1 10:15:46   \n",
       "11              4              2   2019/7/1 10:15:09  ...   2019/7/1 10:15:09   \n",
       "12              4              2   2019/7/1 10:16:40  ...   2019/7/1 10:16:41   \n",
       "13              4              2   2019/7/1 10:25:38  ...   2019/7/1 10:25:39   \n",
       "14              4              2   2019/7/1 10:22:58  ...   2019/7/1 10:22:59   \n",
       "15              4              2   2019/7/1 11:00:11  ...   2019/7/1 11:00:12   \n",
       "16              4              2   2019/7/1 10:29:50  ...   2019/7/1 10:29:51   \n",
       "17              4              2   2019/7/1 10:28:59  ...   2019/7/1 10:28:59   \n",
       "18              4              2   2019/7/1 10:32:13  ...   2019/7/1 10:32:13   \n",
       "19              4              2   2019/7/1 11:00:10  ...   2019/7/1 11:00:10   \n",
       "20              4              2   2019/7/1 10:36:52  ...   2019/7/1 10:36:52   \n",
       "21              4              2   2019/7/1 10:51:56  ...   2019/7/1 10:51:57   \n",
       "22              4              2   2019/7/1 10:43:08  ...   2019/7/1 10:43:09   \n",
       "23              4              2   2019/7/1 11:00:19  ...   2019/7/1 11:00:20   \n",
       "24              4              2   2019/7/1 10:57:31  ...   2019/7/1 10:57:32   \n",
       "25              4              2   2019/7/1 10:57:41  ...   2019/7/1 10:57:41   \n",
       "26              4              2   2019/7/1 11:01:37  ...   2019/7/1 11:01:37   \n",
       "27              4              2   2019/7/1 11:06:17  ...   2019/7/1 11:06:17   \n",
       "28              4              2   2019/7/1 11:07:38  ...   2019/7/1 11:07:39   \n",
       "29              4              2   2019/7/1 11:06:22  ...   2019/7/1 11:06:22   \n",
       "...           ...            ...                 ...  ...                 ...   \n",
       "14135           4              2  2019/7/31 19:15:34  ...  2019/7/31 19:15:35   \n",
       "14136           4              2  2019/7/31 20:48:29  ...  2019/7/31 20:48:29   \n",
       "14137           4              2  2019/7/31 21:19:07  ...  2019/7/31 21:19:08   \n",
       "14138           4              2  2019/7/31 21:01:12  ...  2019/7/31 21:01:12   \n",
       "14139           4              2  2019/7/31 21:16:35  ...  2019/7/31 21:16:36   \n",
       "14140           4              2  2019/7/31 21:13:16  ...  2019/7/31 21:13:16   \n",
       "14141           4              2  2019/7/31 21:35:16  ...  2019/7/31 21:35:17   \n",
       "14142           4              2  2019/7/31 21:16:22  ...  2019/7/31 21:16:23   \n",
       "14143           4              2  2019/7/31 21:11:18  ...  2019/7/31 21:11:18   \n",
       "14144           4              2  2019/7/31 21:21:56  ...  2019/7/31 21:21:56   \n",
       "14145           4              2  2019/7/31 20:01:52  ...  2019/7/31 20:01:52   \n",
       "14146           4              2  2019/7/31 21:24:26  ...  2019/7/31 21:24:26   \n",
       "14147           4              2  2019/7/31 20:00:24  ...  2019/7/31 20:00:24   \n",
       "14148           4              2  2019/7/31 19:51:18  ...  2019/7/31 19:51:19   \n",
       "14149           4              2  2019/7/31 20:03:35  ...  2019/7/31 20:03:36   \n",
       "14150           4              2  2019/7/31 21:39:54  ...  2019/7/31 21:39:54   \n",
       "14151           4              2  2019/7/31 20:49:41  ...  2019/7/31 20:49:42   \n",
       "14152           4              2  2019/7/31 20:23:07  ...  2019/7/31 20:23:08   \n",
       "14153           4              2  2019/7/31 20:13:52  ...  2019/7/31 20:13:53   \n",
       "14154           4              2  2019/7/31 20:25:56  ...  2019/7/31 20:25:57   \n",
       "14155           4              2  2019/7/31 20:19:15  ...  2019/7/31 20:19:16   \n",
       "14156           4              2  2019/7/31 20:23:48  ...  2019/7/31 20:23:49   \n",
       "14157           4              2  2019/7/31 20:39:38  ...  2019/7/31 20:39:38   \n",
       "14158           4              2  2019/7/31 20:42:29  ...  2019/7/31 20:42:30   \n",
       "14159           4              2  2019/7/31 20:40:13  ...  2019/7/31 20:40:13   \n",
       "14160           4              2  2019/7/31 21:25:59  ...  2019/7/31 21:25:59   \n",
       "14161           4              2  2019/7/31 20:58:18  ...  2019/7/31 20:58:19   \n",
       "14162           4              2  2019/7/31 21:25:33  ...  2019/7/31 21:25:33   \n",
       "14163           4              2  2019/7/31 20:52:49  ...  2019/7/31 20:52:50   \n",
       "14164           4              2  2019/7/31 21:02:03  ...  2019/7/31 21:02:03   \n",
       "\n",
       "      UPDATED_BY.1        UPDATED_TIME ACTIVITY_ID     SEQ_NO  ARCHIVE_FLAG  \\\n",
       "0       BILLCENTER    2019/7/1 9:32:11         NaN  222960176             0   \n",
       "1       BILLCENTER   2019/8/3 10:43:02         NaN  222964154             0   \n",
       "2       BILLCENTER   2019/8/3 19:35:35         NaN  222968036             0   \n",
       "3       BILLCENTER   2019/8/8 12:54:49         NaN  222964498             0   \n",
       "4       BILLCENTER    2019/8/3 9:47:24         NaN  222968572             0   \n",
       "5       BILLCENTER   2019/8/8 12:54:49         NaN  222968282             0   \n",
       "6       BILLCENTER   2019/8/5 17:29:44         NaN  222971880             0   \n",
       "7       BILLCENTER    2019/8/4 3:56:31         NaN  223071592             0   \n",
       "8       BILLCENTER   2019/8/3 21:13:05         NaN  222980836             0   \n",
       "9       BILLCENTER   2019/8/8 12:54:49         NaN  222984712             0   \n",
       "10      BILLCENTER   2019/8/3 22:35:58         NaN  222989490             0   \n",
       "11      BILLCENTER   2019/7/1 10:15:33         NaN  222989002             0   \n",
       "12      BILLCENTER   2019/7/1 10:19:26         NaN  222989382             0   \n",
       "13      BILLCENTER    2019/8/3 8:33:18         NaN  222995344             0   \n",
       "14      BILLCENTER   2019/8/3 19:57:15         NaN  222993864             0   \n",
       "15      BILLCENTER   2019/8/3 10:56:45         NaN  223018900             0   \n",
       "16      BILLCENTER   2019/7/1 14:21:11         NaN  222997834             0   \n",
       "17      BILLCENTER   2019/8/3 20:57:50         NaN  222997170             0   \n",
       "18      BILLCENTER   2019/8/4 22:35:53         NaN  222999644             0   \n",
       "19      BILLCENTER   2019/8/3 10:28:19         NaN  223018852             0   \n",
       "20      BILLCENTER   2019/8/4 11:19:13         NaN  223002924             0   \n",
       "21      BILLCENTER   2019/8/3 19:49:28         NaN  223012588             0   \n",
       "22      BILLCENTER   2019/8/3 20:50:23         NaN  223006502             0   \n",
       "23      BILLCENTER    2019/8/4 4:50:37         NaN  223019020             0   \n",
       "24      BILLCENTER   2019/8/2 15:14:17         NaN  223016946             0   \n",
       "25      BILLCENTER   2019/8/4 16:32:37         NaN  223017218             0   \n",
       "26      BILLCENTER   2019/7/1 11:48:25         NaN  223020040             0   \n",
       "27      BILLCENTER    2019/8/5 9:58:43         NaN  223023448             0   \n",
       "28      BILLCENTER   2019/8/6 13:59:21         NaN  223024562             0   \n",
       "29      BILLCENTER    2019/8/4 4:50:37         NaN  223022852             0   \n",
       "...            ...                 ...         ...        ...           ...   \n",
       "14135   BILLCENTER   2019/8/8 16:38:40         NaN  237858920             0   \n",
       "14136   BILLCENTER  2019/7/31 20:55:38         NaN  237901536             0   \n",
       "14137   BILLCENTER   2019/8/8 16:38:45         NaN  237910700             0   \n",
       "14138   BILLCENTER   2019/8/8 16:38:45         NaN  237905748             0   \n",
       "14139   BILLCENTER  2019/7/31 21:53:58         NaN  237909740             0   \n",
       "14140   BILLCENTER   2019/8/8 16:38:46         NaN  237909184             0   \n",
       "14141   BILLCENTER   2019/8/9 11:02:40         NaN  237914678             0   \n",
       "14142   BILLCENTER   2019/8/8 16:38:45         NaN  237909894             0   \n",
       "14143   BILLCENTER   2019/8/8 16:38:48         NaN  237908520             0   \n",
       "14144   BILLCENTER   2019/8/8 16:38:30         NaN  237911190             0   \n",
       "14145   BILLCENTER   2019/8/8 16:38:40         NaN  237883788             0   \n",
       "14146   BILLCENTER   2019/8/8 16:38:45         NaN  237912310             0   \n",
       "14147   BILLCENTER   2019/8/8 16:38:30         NaN  237883240             0   \n",
       "14148   BILLCENTER   2019/8/8 16:38:45         NaN  237878665             0   \n",
       "14149   BILLCENTER   2019/8/8 16:38:35         NaN  237884436             0   \n",
       "14150   BILLCENTER   2019/8/8 16:38:36         NaN  237915570             0   \n",
       "14151   BILLCENTER   2019/8/8 16:38:48         NaN  237902118             0   \n",
       "14152   BILLCENTER  2019/7/31 20:40:18         NaN  237892456             0   \n",
       "14153   BILLCENTER   2019/8/8 16:38:41         NaN  237888688             0   \n",
       "14154   BILLCENTER   2019/8/8 16:38:35         NaN  237893684             0   \n",
       "14155   BILLCENTER   2019/8/8 16:38:48         NaN  237891032             0   \n",
       "14156   BILLCENTER   2019/8/8 16:38:40         NaN  237892872             0   \n",
       "14157   BILLCENTER   2019/8/8 16:38:31         NaN  237898806             0   \n",
       "14158   BILLCENTER   2019/8/8 16:38:41         NaN  237900032             0   \n",
       "14159   BILLCENTER   2019/8/8 16:38:40         NaN  237898830             0   \n",
       "14160   BILLCENTER   2019/8/8 16:38:41         NaN  237912678             0   \n",
       "14161   BILLCENTER   2019/8/8 16:38:35         NaN  237905136             0   \n",
       "14162   BILLCENTER  2019/7/31 21:38:29         NaN  237912528             0   \n",
       "14163   BILLCENTER   2019/8/8 16:38:48         NaN  237903214             0   \n",
       "14164   BILLCENTER   2019/8/8 16:38:35         NaN  237906152             0   \n",
       "\n",
       "      FROZEN_CAL_DATE WITHHOLD_STATUS  PARTITION_NUM  REMARK.1  \n",
       "0                 NaN           READY           7869       NaN  \n",
       "1                 NaN           READY           7869       NaN  \n",
       "2                 NaN           READY           7869       NaN  \n",
       "3                 NaN           READY           7869       NaN  \n",
       "4                 NaN           READY           7869       NaN  \n",
       "5                 NaN           READY           7869       NaN  \n",
       "6                 NaN           READY           7868       NaN  \n",
       "7                 NaN           READY           7869       NaN  \n",
       "8                 NaN           READY           7868       NaN  \n",
       "9                 NaN           READY           7869       NaN  \n",
       "10                NaN           READY           7868       NaN  \n",
       "11                NaN           READY           7869       NaN  \n",
       "12                NaN           READY           7869       NaN  \n",
       "13                NaN           READY           7869       NaN  \n",
       "14                NaN           READY           7869       NaN  \n",
       "15                NaN           READY           7869       NaN  \n",
       "16                NaN           READY           7869       NaN  \n",
       "17                NaN           READY           7869       NaN  \n",
       "18                NaN           READY           7869       NaN  \n",
       "19                NaN           READY           7869       NaN  \n",
       "20                NaN           READY           7869       NaN  \n",
       "21                NaN           READY           7869       NaN  \n",
       "22                NaN           READY           7869       NaN  \n",
       "23                NaN           READY           7869       NaN  \n",
       "24                NaN           READY           7869       NaN  \n",
       "25                NaN           READY           7869       NaN  \n",
       "26                NaN           READY           7869       NaN  \n",
       "27                NaN           READY           7869       NaN  \n",
       "28                NaN           READY           7869       NaN  \n",
       "29                NaN           READY           7869       NaN  \n",
       "...               ...             ...            ...       ...  \n",
       "14135             NaN           READY           8997       NaN  \n",
       "14136             NaN           READY           8997       NaN  \n",
       "14137             NaN           READY           8997       NaN  \n",
       "14138             NaN           READY           8997       NaN  \n",
       "14139             NaN           READY           8997       NaN  \n",
       "14140             NaN           READY           8997       NaN  \n",
       "14141             NaN           READY           8997       NaN  \n",
       "14142             NaN           READY           8997       NaN  \n",
       "14143             NaN           READY           8997       NaN  \n",
       "14144             NaN           READY           8997       NaN  \n",
       "14145             NaN           READY           8997       NaN  \n",
       "14146             NaN           READY           8997       NaN  \n",
       "14147             NaN           READY           8997       NaN  \n",
       "14148             NaN           READY           8997       NaN  \n",
       "14149             NaN           READY           8997       NaN  \n",
       "14150             NaN           READY           8997       NaN  \n",
       "14151             NaN           READY           8997       NaN  \n",
       "14152             NaN           READY           8997       NaN  \n",
       "14153             NaN           READY           8997       NaN  \n",
       "14154             NaN           READY           8997       NaN  \n",
       "14155             NaN           READY           8997       NaN  \n",
       "14156             NaN           READY           8997       NaN  \n",
       "14157             NaN           READY           8997       NaN  \n",
       "14158             NaN           READY           8997       NaN  \n",
       "14159             NaN           READY           8997       NaN  \n",
       "14160             NaN           READY           8997       NaN  \n",
       "14161             NaN           READY           8997       NaN  \n",
       "14162             NaN           READY           8997       NaN  \n",
       "14163             NaN           READY           8997       NaN  \n",
       "14164             NaN           READY           8997       NaN  \n",
       "\n",
       "[14165 rows x 132 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import os\n",
    "os.chdir(r'C:\\Users\\程博\\Desktop\\7yue')\n",
    "\n",
    "df = pd.read_csv('7yue815.csv')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-08-15T07:15:08.488658Z",
     "start_time": "2019-08-15T07:15:08.467718Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "249"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['REPAY_TIME']=pd.to_datetime(df.REPAY_TIME,format='%Y-%m-%d')\n",
    "df[df['REPAY_TIME']>'2019-08-11'].shape[0]+df[df['STATUS']=='OPEN'].shape[0]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-08-15T07:34:50.408535Z",
     "start_time": "2019-08-15T07:34:50.347698Z"
    }
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "215"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1 = df[df['FINISH_REPAY_FLAG']==0].copy()\n",
    "df1[df1['REPAY_TIME']>'2019-08-11'].shape[0]+df1[df1['STATUS']=='OPEN'].shape[0]\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-08-15T08:16:52.173910Z",
     "start_time": "2019-08-15T08:16:51.935547Z"
    }
   },
   "outputs": [
    {
     "ename": "PermissionError",
     "evalue": "[Errno 13] Permission denied: 'r.xlsx'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mPermissionError\u001b[0m                           Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-29-7ede31027230>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[0;32m      1\u001b[0m \u001b[0mdf2\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mdf\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mdf\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'FINISH_REPAY_FLAG'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m==\u001b[0m\u001b[1;36m1\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcopy\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 2\u001b[1;33m \u001b[0mdf2\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mdf2\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'REPAY_TIME'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m>\u001b[0m\u001b[1;34m'2019-08-11'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mto_excel\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'r.xlsx'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m      3\u001b[0m \u001b[0mdf2\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mdf2\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'STATUS'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m==\u001b[0m\u001b[1;34m'OPEN'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mto_excel\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'o.xlsx'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mC:\\ProgramData\\Anaconda3\\lib\\site-packages\\pandas\\core\\generic.py\u001b[0m in \u001b[0;36mto_excel\u001b[1;34m(self, excel_writer, sheet_name, na_rep, float_format, columns, header, index, index_label, startrow, startcol, engine, merge_cells, encoding, inf_rep, verbose, freeze_panes)\u001b[0m\n\u001b[0;32m   2125\u001b[0m         formatter.write(excel_writer, sheet_name=sheet_name, startrow=startrow,\n\u001b[0;32m   2126\u001b[0m                         \u001b[0mstartcol\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mstartcol\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mfreeze_panes\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mfreeze_panes\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 2127\u001b[1;33m                         engine=engine)\n\u001b[0m\u001b[0;32m   2128\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   2129\u001b[0m     def to_json(self, path_or_buf=None, orient=None, date_format=None,\n",
      "\u001b[1;32mC:\\ProgramData\\Anaconda3\\lib\\site-packages\\pandas\\io\\formats\\excel.py\u001b[0m in \u001b[0;36mwrite\u001b[1;34m(self, writer, sheet_name, startrow, startcol, freeze_panes, engine)\u001b[0m\n\u001b[0;32m    662\u001b[0m                            freeze_panes=freeze_panes)\n\u001b[0;32m    663\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mneed_save\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 664\u001b[1;33m             \u001b[0mwriter\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0msave\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;32mC:\\ProgramData\\Anaconda3\\lib\\site-packages\\pandas\\io\\excel.py\u001b[0m in \u001b[0;36msave\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m   1950\u001b[0m         \"\"\"\n\u001b[0;32m   1951\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 1952\u001b[1;33m         \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mbook\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mclose\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   1953\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   1954\u001b[0m     def write_cells(self, cells, sheet_name=None, startrow=0, startcol=0,\n",
      "\u001b[1;32mC:\\ProgramData\\Anaconda3\\lib\\site-packages\\xlsxwriter\\workbook.py\u001b[0m in \u001b[0;36mclose\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m    304\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mfileclosed\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    305\u001b[0m             \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mfileclosed\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;36m1\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 306\u001b[1;33m             \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_store_workbook\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    307\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    308\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0mset_size\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mwidth\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mheight\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mC:\\ProgramData\\Anaconda3\\lib\\site-packages\\xlsxwriter\\workbook.py\u001b[0m in \u001b[0;36m_store_workbook\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m    653\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    654\u001b[0m         xlsx_file = ZipFile(self.filename, \"w\", compression=ZIP_DEFLATED,\n\u001b[1;32m--> 655\u001b[1;33m                             allowZip64=self.allow_zip64)\n\u001b[0m\u001b[0;32m    656\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    657\u001b[0m         \u001b[1;31m# Add XML sub-files to the Zip file with their Excel filename.\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mC:\\ProgramData\\Anaconda3\\lib\\zipfile.py\u001b[0m in \u001b[0;36m__init__\u001b[1;34m(self, file, mode, compression, allowZip64, compresslevel)\u001b[0m\n\u001b[0;32m   1202\u001b[0m             \u001b[1;32mwhile\u001b[0m \u001b[1;32mTrue\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   1203\u001b[0m                 \u001b[1;32mtry\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 1204\u001b[1;33m                     \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mfp\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mio\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mopen\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mfile\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mfilemode\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m   1205\u001b[0m                 \u001b[1;32mexcept\u001b[0m \u001b[0mOSError\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m   1206\u001b[0m                     \u001b[1;32mif\u001b[0m \u001b[0mfilemode\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mmodeDict\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mPermissionError\u001b[0m: [Errno 13] Permission denied: 'r.xlsx'"
     ]
    }
   ],
   "source": [
    "df2 = df[df['FINISH_REPAY_FLAG']==1].copy()\n",
    "df2[df2['REPAY_TIME']>'2019-08-11'].to_excel('r.xlsx')\n",
    "df2[df2['STATUS']=='OPEN'].to_excel('o.xlsx')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {
    "ExecuteTime": {
     "end_time": "2019-08-15T08:17:23.652834Z",
     "start_time": "2019-08-15T08:17:23.169133Z"
    }
   },
   "outputs": [],
   "source": [
    "df3 = df[df['FINISH_REPAY_FLAG']==1].copy()\n",
    "df3.to_excel('f1.xlsx')"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  },
  "varInspector": {
   "cols": {
    "lenName": 16,
    "lenType": 16,
    "lenVar": 40
   },
   "kernels_config": {
    "python": {
     "delete_cmd_postfix": "",
     "delete_cmd_prefix": "del ",
     "library": "var_list.py",
     "varRefreshCmd": "print(var_dic_list())"
    },
    "r": {
     "delete_cmd_postfix": ") ",
     "delete_cmd_prefix": "rm(",
     "library": "var_list.r",
     "varRefreshCmd": "cat(var_dic_list()) "
    }
   },
   "types_to_exclude": [
    "module",
    "function",
    "builtin_function_or_method",
    "instance",
    "_Feature"
   ],
   "window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
